| 176 |
1Z0-067 |
Which two statements are true when row-archival management is enabled?
|
|
Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
|
The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer
considered active.
|
The row archival visibility session parameter defaults to all rows.
|
The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
|
The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered
active. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
 |
 |
| 175 |
1Z0-067 |
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c. |
175-quept2.png |
The valid time columns employee_time_start and employee_time_end are automatically created.
|
The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses. |
The valid time columns are not populated by the Oracle Server automatically.
|
The valid time columns are visible by default when the table is described.
|
. Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and
queries performed by the session. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2,5 |
|
MC |
|
|
| 174 |
1Z0-067 |
You want RMAN to make duplicate copies of data files when using the backup command.
What must you set using the RMAN configure command to achieve this?
|
|
MAXSETSIZE TO 2; |
DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; |
CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U'; |
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 173 |
1Z0-067 |
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? |
|
RMAN recovery catalog
|
RMAN Media Management Library
|
Enterprise Manager Cloud Control
|
Enterprise Manager Database Express |
Oracle Secure Backup
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 172 |
1Z0-067 |
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?
|
|
The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs
percent used |
Setting the target tablespace to read-only after the segments are moved
|
The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds
T3S percent used |
Taking the target tablespace offline after the segments are moved
|
The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs
percent used |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 171 |
1Z0-067 |
A database is running in archivelog mode. The database contains locally managed tablespaces. |
171-quept2.png |
The backup succeeds only if all the tablespaces are locally managed.
|
The backup succeeds only if the RMAN default device for backup is set to disk.
|
The backup fails because you cannot specify section size for a compressed backup. |
The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 170 |
1Z0-067 |
Examine the RMAN command: |
170-quept2.png |
The password for the encryption must be set up.
|
Oracle wallet for the encryption must be set up.
|
All the tablespaces in the database must be encrypted.
|
Oracle Database Vault must be enabled.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 169 |
1Z0-067 |
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): |
169-quept2.png |
It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
|
It fails and reports an error because the container=all clause is not used.
|
It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
|
It fails and reports an error because the comtainer=current clause is not used.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 168 |
1Z0-067 |
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). |
168-quept2.png |
C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
|
B_admin can create and select any table in both the root container and kr_pdb.
|
c##admin can create and select any table in the root container and all the PDBs.
|
B_admin can create and select any table only in hr_pdb.
|
The grant c=»role1 to b_admin command returns an error because container should be set to ALL.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 167 |
1Z0-067 |
You wish to create jobs to satisfy these requirements: |
167-quept2.png |
Create both jobs by using Scheduler raised events.
|
Create both jobs using application raised events.
|
Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
|
Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 166 |
1Z0-067 |
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. |
166.png |
2, 1, 3, 7, 6, and 8
|
2, 1, 4, 5, 3, 7, 6, 9, and 8
|
2, 1, 3, 7, 6, 9, and 8
|
2, 1, 3, 5, 7, 6, and 8
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 165 |
1Z0-067 |
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. |
165-quept2.png |
It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
|
It is set to /u01/app/oracle/admin/enl2r&p/adump.
|
It is set to /u01/app/oracle.
|
It is set to /u01/app/oracle/flash_recovery_area.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 164 |
1Z0-067 |
Which two are prerequisites for setting up Flashback Data Archive?
|
|
Fast Recovery Area should be defined.
|
Undo retention guarantee should be enabled.
|
Supplemental logging should be enabled.
|
Automatic Undo Management should be enabled.
|
All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
|
The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,6 |
|
MC |
|
|
| 163 |
1Z0-067 |
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? |
|
The current online redo log file is missing.
|
A data file belonging to a noncritical tablespace is missing.
|
All the control files are missing.
|
The database backup is older than the control file backup.
|
All the data files are missing.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 162 |
1Z0-067 |
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time. |
162-quept2.png |
1, 4, 3
|
1, 2
|
1, 4, 3, 2
|
1, 2, 4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 161 |
1Z0-067 |
Which three statements are true about a job chain?
|
|
It can contain a nested chain of jobs.
|
It can be used to implement dependency-based scheduling.
|
It cannot invoke the same program or nested chain in multiple steps in the chain.
|
It cannot have more than one dependency.
|
It can be executed using event-based or time-based schedules.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2,5 |
|
MC |
|
|
| 160 |
1Z0-067 |
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use? |
|
Database Replay
|
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
|
Active Session History (ASH) report
|
SQL Performance Analyzer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 159 |
1Z0-067 |
For which three pieces of information can you use the RMAN list command?
|
|
stored scripts in the recovery catalog
|
available archived redo log files
|
backup sets and image copies that are obsolete
|
backups of tablespaces
|
backups that are marked obsolete according to the current retention policy
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,4 |
|
MC |
|
|
| 158 |
1Z0-067 |
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?
|
|
Set the backup_tape_io_slaves parameter to true.
|
Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
|
Configure large pool if not already done.
|
Remove the rate parameter, if specified, in the allocate channel command.
|
Always use RMAN compression for tape backups rather than the compression provided by media manager.
|
Always use synchronous I/O for the database.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4,6 |
|
MC |
|
|
| 157 |
1Z0-067 |
Which two statements are true about scheduling operations in a pluggable database (PDB)?
|
|
Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
|
A job defined in a PDB runs only if that PDB is open.
|
Scheduler attribute setting is performed only at the CDB level.
|
Scheduler objects created by users can be exported or imported using Data Pump.
|
Scheduler jobs for a PDB can be created only by common users.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
| 156 |
1Z0-067 |
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): |
156-quept2.png |
The command fails and gives an error because object privileges cannot be granted to a common user.
|
The command fails because container is not set to current.
|
The command succeeds and the common user cmadnxn can create a session and query the D3A_users view in cdbssoo? and all the PDBs.
|
The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?
cdt. |
The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
|
|
| 155 |
1Z0-067 |
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. |
155-quept2.png |
It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
|
It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
|
It executes successfully and continues to store metadata related to the EMPLOYEES table.
|
It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 154 |
1Z0-067 |
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?
|
|
It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
|
It creates a file that contains the SQL statement, which is required to re-create the control file.
|
It updates the alert log file with the location and contents of the control file.
|
It creates a binary backup of the control file.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 153 |
1Z0-067 |
The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. |
153-quept2.png |
It fails because the target database and recovery catalog database are of different versions.
|
It succeeds and all global scripts in the sc:: catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
|
It succeeds but the database is not automatically registered in the Rc12c catalog.
|
It fails because RMAN is not connected to the target database with DBID=1423241.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 152 |
1Z0-067 |
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user. |
152-quept2.png |
It fails because the target database and recovery catalog database are of different versions.
|
It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
|
It succeeds but the database is not automatically registered in the rc:2c catalog.
|
It fails because RMAN is not connected to the target database with r3:T=:42324:.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 151 |
1Z0-067 |
Which two statements are true regarding Oracle Data Pump?
|
|
EXPDP and IMPDP are the client components of Oracle Data Pump.
|
DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
|
Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
|
Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
|
EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 150 |
1Z0-067 |
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
|
|
to store backup information of multiple databases in one place
|
to restrict the amount of space that is used by backups
|
to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
|
to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog
|
to automatically delete obsolete backups after a specified period of time
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4,5 |
|
MC |
|
|
| 149 |
1Z0-067 |
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
|
|
A DBA can check specific tables with the DMU
|
The database to be migrated must be opened read-only.
|
The release of the database to be converted can be any release since 9.2.0.8.
|
The DMU can report columns that are too long in the converted characterset
|
The DMU can report columns that are not represented in the converted characterset
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4,5 |
|
MC |
|
|
| 148 |
1Z0-067 |
Examine the command to duplicate a database: |
148-quept2.png |
The SPFILE is copied along with the data files of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also
duplicated. |
A backup of pdbi and pd35 must exist before executing the command.
|
The duplicate command first creates a backup, and then duplicates the PDBs by using the
|
backup |
An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,5 |
|
MC |
|
|
| 147 |
1Z0-067 |
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing singleinstance database. Which step should you perform next to start the upgrade of the database?
|
|
Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log
files during the upgrade.
|
Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel
upgrade options that reduce down time. |
Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
|
Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade
operations. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 146 |
1Z0-067 |
You issue the RMAN commands: |
146-quept2.png |
switching the online redo log file
|
backing up all data files as image copies and archive log files, and deleting those archive log files
|
backing up only the used blocks in the data files
|
backing up all used and unused blocks in the data files
|
backing up all archived log files and marking them as obsolete
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,5 |
|
MC |
|
|
| 145 |
1Z0-067 |
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
|
|
By default, EM express is available for a database after database creation.
|
You can use EM express to manage multiple databases running on the same server.
|
You can perform basic administrative tasks for pluggable databases by using the EM express interface.
|
You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
|
You can create and configure pluggable databases by using EM express.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 144 |
1Z0-067 |
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this
setting? |
|
DATE |
TIMESTAMP |
INTERVAL YEAR TO MONTH
|
INTERVAL DAY TO SECOND
|
TIMESTAMP WITH LOCAL TIME ZONE
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,5 |
|
MC |
|
|
| 143 |
1Z0-067 |
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
|
|
Database Resident Connection Pooling
|
Oracle Suggested Backup Strategy
|
Database Vault in ORACLE_HOME
|
Nondefaultblocksizetablespaces
|
Configure Label Security
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,5 |
|
MC |
|
|
| 142 |
1Z0-067 |
When is the UNDO_RETENTION parameter value ignored by a transaction?
|
|
when the data file of the undo tablespace is autoextensible
|
when there are multiple undotablespaces available in a database
|
when the undo tablespace is of a fixed size and retention guarantee is not enabled
|
when Flashback Database is enabled
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 141 |
1Z0-067 |
Which two statements are true about tablespaces in multitenant container databases (CDBs)?
|
|
Default permanent tablespaces can be shared across pluggable databases (PDBs).
|
The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
|
Each PDB can have its own default temporary tablespace.
|
The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
|
The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 140 |
1Z0-067 |
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
|
|
Oracle Data Pump
|
Oracle Recovery Manager (RMAN)
|
Oracle Recovery Manager (RMAN)
|
Oracle Database Vault
|
Oracle Real Application Security
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 139 |
1Z0-067 |
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: |
139-quept2.png |
It succeeds and displays all the tablespaces that belong to the root database.
|
It fails and returns an error because a connection is not made by using the sysdba privilege.
|
It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
|
It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 138 |
1Z0-067 |
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
|
|
The PDB is closed and the temp file is re-created automatically when the PDB is opened.
|
The PDB is closed and requires media recovery at the PDB level.
|
The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
|
The PDB does not close and starts by using the default temporary tablespace defined for the CD
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 137 |
1Z0-067 |
Examine the RMAN commands executed in your database: |
137-quept2.png |
It performs a log switch.
|
It creates compressed backup sets by using binary compression by default.
|
It backs up only the used blocks in data files.
|
It backs up data files, the control file, and the server parameter file.
|
It creates a backup of only the control file whenever the database undergoes a structural change.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,5 |
|
MC |
|
|
| 136 |
1Z0-067 |
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You
want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
|
|
All the read-only tablespaces should be taken offline.
|
All the read-only tablespaces should be restored separately.
|
All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
|
All the read-only tablespaces should be made online with logging disabled.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 135 |
1Z0-067 |
In a database supporting an OLTP workload, tables are frequently updated on both key and non- keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload? |
|
heap table with a primary key index
|
external table
|
hash clustered table
|
global temporary table
|
index clustered table
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5 |
|
SC |
|
|
| 134 |
1Z0-067 |
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
|
|
If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
|
In a PDB plan, subplans may be used with up to eight consumer groups.
|
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
|
If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
|
If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan
and the shares provided to the consumer groups in the PDB plan. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,5 |
|
MC |
|
|
| 133 |
1Z0-067 |
Examine the output: |
133-quept2.png |
Flashback data archives (FDA)
|
Archived redo log files
|
Control file autobackups
|
Server parameter file (SPFILE)
|
Recovery Manager (RMAN) backup pieces
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,5 |
|
MC |
|
|
| 132 |
1Z0-067 |
Which three requirements must be met before a tablespace can be transported across different platforms?
|
|
Both the source and target databases must use the same character set.
|
The platforms of both the source and target databases must have the same endian format.
|
The compatible parameter value must be the same in the source and target databases.
|
The minimum compatibility level for both the source and target databases must be 10.0.0.
|
The tablespace to be transported must be in read-only mode.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,4 |
|
MC |
|
|
| 131 |
1Z0-067 |
View the SPFILE parameter settings in the Exhibit. |
131.png |
because pga_aggregate_target is not set
|
because statistics_level is set to basic
|
because memory_target and memory_max_target cannot be equal
|
because sga_target and memory_target are both set
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 130 |
1Z0-067 |
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). |
130-quept2.png |
It can create only local users in all the PDBs.
|
It has a common schema for all the PDBs.
|
It can create common users only when it is logged in to the CDB.
|
It can create only local users in the CDB.
|
It can be granted only common roles in the PDBs.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 129 |
1Z0-067 |
Which three statements are true about the database instance startup after an instance failure?
|
|
The RECO process recovers the uncommitted transactions at the next instance startup.
|
Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
|
Uncommitted changes are rolled back to ensure transactional consistency.
|
The SMON process automatically performs the database recovery.
|
Media recovery is required to complete the database recovery.
|
Changes committed before the failure, which were not written to the data files, are re-applied.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,4 |
|
MC |
|
|
| 128 |
1Z0-067 |
Which three statements are true about compression of backup sets?
|
|
Compressed backups can only be written to media.
|
Binary compression creates performance overhead during a backup operation.
|
Unused blocks below the high-water mark are not backed up.
|
Compressed backups cannot have section size defined during a backup operation
|
It works only for locally managed tablespaces.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,5 |
|
MC |
|
|
| 127 |
1Z0-067 |
Which two statements are true regarding SecureFile lobs?
|
|
The amount of undo retained is user controlled.
|
They can be used only for nonpartitioned tables.
|
Fragmentation is minimized by using variable-sized chunks.
|
They support random reads and writes of encrypted LOB data.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
| 126 |
1Z0-067 |
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
|
|
A base recovery catalog should exist.
|
The owner of VPC cannot own recovery catalog.
|
At least one target database should be registered in the recovery catalog.
|
The register database privilege should be granted to the virtual catalog owner.
|
The recovery_catalog_owner role should be granted to the virtual catalog owner.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4,5 |
|
MC |
|
|
| 125 |
1Z0-067 |
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command? |
|
Block change tracking must be enabled before executing this command.
|
The database must be running in archivelog mode for the successful execution of this command.
|
A complete database backup must exist before executing this command.
|
The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
|
The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 124 |
1Z0-067 |
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). |
124-quept2.png |
It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
|
It is granted to the c##admin user only in the CDB.
|
It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
|
It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 123 |
1Z0-067 |
Which three statements are true about unplugging a pluggable database (PDB)?
|
|
The PDB must be open in read only mode.
|
The PDB must be dosed.
|
The unplugged PDB becomes a non-CDB.
|
The unplugged PDB can be plugged into the same multitenant container database (CDB)
|
The unplugged PDB can be plugged into another CDB.
|
The PDB data files are automatically removed from disk. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,4,5 |
|
MC |
|
|
| 122 |
1Z0-067 |
Which two statements are true about Flashback Version Query?
|
|
The result of a query can be used as part of a DML statement.
|
It can be used to create views.
|
It can be used only if Flashback Data Archive is enabled for a table.
|
It retrieves all versions of rows that exist in a time interval, including the start time and end time.
|
It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3 |
|
MC |
|
|
| 121 |
1Z0-067 |
Which three statements are true about Consolidated Database Replay?
|
|
The workload capture and replay systems must have the same operating system (OS).
|
Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database
(CDB) |
A subset of the captured workload can be replayed.
|
The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
|
Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,5 |
|
MC |
|
|
| 120 |
1Z0-067 |
You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?
|
|
Use job classes.
|
Use scheduler windows.
|
Use the mapping rule for the consumer groups.
|
Set the switch_time plan directive for both plans.
|
Use scheduler schedules.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 119 |
1Z0-067 |
Examine the following set of RMAN commands: |
119.png |
The script is executed and both DC1 and chi channels are used for script execution.
|
The execution of the script fails because multiple channels cannot exist simultaneously.
|
The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.
|
The new channel, chi, is ignored because a channel has been configured already.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 118 |
1Z0-067 |
Which parameter must be set to which value to implement automatic PGA memory management?
|
|
Set memory_target to zero.
|
Set STATISTICS_LEVEL to BASIC.
|
Set pga_aggregate_target to a nonzero value.
|
Set pga_aggregate_target and sga_target to the same value.
|
Set sgajtarget to zero.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 117 |
1Z0-067 |
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use? |
|
Compare Period ADDM report
|
AWR Compare Period report
|
Active Session History (ASH) report
|
taking a new snapshot and comparing it with a preserved snapshot
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 116 |
1Z0-067 |
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed
(HCC) format.
Which three storage options support the use of HCC? |
|
ASM disk groups with ASM disks consisting of Exadata Grid Disks.
|
ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
|
ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
|
Database files stored in ZFS and accessed using conventional NFS mounts.
|
Database files stored in ZFS and accessed using the Oracle Direct NFS feature
|
Database files stored in any file system and accessed using the Oracle Direct NFS feature
|
ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,5,7 |
|
MC |
|
|
| 115 |
1Z0-067 |
Your database is running in archivelog mode. |
115-quept2.png |
7, 6, 1, 2, 3, 5, 4
|
7, 2, 1, 3, 5, 8
|
7, 6, 1, 2, 9, 10, 8
|
7, 6, 1, 2, 9, 10, 4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 114 |
1Z0-067 |
Which two statements are true about unified auditing? |
|
A unified audit trail captures audit information from unified audit policies and audit settings.
|
Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
|
Audit records are created for all users except sys.
|
Audit records are created only for the DML and DDL operations performed on database objects.
|
Unified auditing is enabled by setting the audit_trail parameter to db, extended.
|
A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,6 |
|
MC |
|
|
| 113 |
1Z0-067 |
You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next? |
|
Execute catproc.sqi to recompile invalid PL/SQL modules.
|
Open the database with the resetlogs option.
|
Set a new database identifier (DBID) for the newly restored database.
|
Use the RMAN set newname and switch commands to switch to new files.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 112 |
1Z0-067 |
Which three statements are true about persistent lightweight jobs? |
|
A user cannot set privileges on them.
|
They generate large amounts of metadata.
|
They may be created as fully self-contained jobs.
|
They must reference an existing Scheduler Program.
|
The are useful when users need to create a large number of jobs quickly.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4,5 |
|
MC |
|
|
| 111 |
1Z0-067 |
Your database supports an OLTP workload. |
111-quept2.png |
Automatic checkpoint tuning is disabled.
|
The frequency of log switches is increased.
|
The overhead on database performance is increased because of frequent writes to disk.
|
The MTTR advisor is disabled.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 110 |
1Z0-067 |
You set the following parameters in the parameter file and restart the database instance: |
110-quept2.png |
The memory_max_target parameter is automatically set to 500 MB.
|
The pga_aggregate_target and sga_target parameters are automatically set to zero.
|
The value of the memory_max_target parameter remains zero for the database instance.
|
The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
|
The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to
nonzero values. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3 |
|
MC |
|
|
| 109 |
1Z0-067 |
Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013.
The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk.
Which statement is true about the backup of the tools tablespace? |
|
The RMAN backup fails because the tools tablespace is read-only.
|
RMAN skips the backup of the tools tablespace because backup optimization is enabled.
|
RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
|
|
RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 108 |
1Z0-067 |
Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database? |
|
Enable minimal supplemental logging.
|
Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
|
Enable the recyclebin.
|
Enable undo retention guarantee.
|
Enable Fast Recovery Area.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3 |
|
MC |
|
|
| 107 |
1Z0-067 |
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true? |
|
A resumable statement can be suspended and resumed only once during execution.
|
Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
|
A suspended statement will report an error if no corrective action has taken place during a timeout period.
|
Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
|
Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
|
|
| 106 |
1Z0-067 |
Examine the command and its output: |
106-quept2.png |
It flashes back the employee table and all the constraints associated with the table.
|
It automatically flashes back all the indexes on the employes table.
|
It automatically flashes back any triggers defined on the table.
|
It flashes back only the structure of the table and not the data.
|
It flashes back the data from the recycle bin and the existing data in the original table is permanently lost. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,4 |
|
MC |
|
|
| 105 |
1Z0-067 |
You want to move your existing recovery catalog to another database. |
105.png |
1, 6, 4
|
2, 3, 7, 5
|
1, 2, 6, 4
|
1, 2, 3, 6, 5
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 104 |
1Z0-067 |
Which two statements are true about service creation for pluggable databases (PDBs)?
|
|
When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
|
The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
|
A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
|
Only a common user can create additional services for a PDB.
|
When a PDB is created, a service with the same name as the PDB is created in the PDB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
| 103 |
1Z0-067 |
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs
transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?
|
|
Enable temporary undo for the database.
|
Enable undo retention guarantee.
|
Increase the size of the redo log buffer.
|
Enable Automatic Memory Management (AMM).
|
Increase the size of the temporary tablespace.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,5 |
|
MC |
|
|
| 102 |
1Z0-067 |
A user issues a query on the sales table. |
102-quept2.png |
Drop the tenpOi.dbf file, and then re-create the temp file.
|
Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.
|
Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
|
Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
|
Create a new temporary tablespace and assign it as the default to the user.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,5 |
|
MC |
|
|
| 101 |
1Z0-067 |
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. |
101-quept2.png |
All archive redo log files are automatically copied to the duplicate database.
|
The duplicate database has the same directory structure as the source database.
|
The duplicate database is created by using the backups created during the execution of
|
the duplicate command.
|
The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
|
The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,6 |
|
MC |
|
|
| 100 |
1Z0-067 |
Examine the parameters for your database instance: |
100-quept2.png |
The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution
statistics. |
The optimizer can re optimize a query only once using cardinality feedback.
|
The optimizer enables monitoring for cardinality feedback after the first execution of a query.
|
The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
|
After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,4 |
|
MC |
|
|
| 99 |
1Z0-067 |
Which three statements are true about Oracle Restart?
|
|
It can be configured to automatically attempt to restart various components after a hardware or software failure.
|
While starting any components, it automatically attempts to start all dependencies first and in proper order.
|
It can be configured to automatically restart a database in case of normal shutdown of the database instance.
|
It can be used to only start Oracle components.
|
It runs periodic check operations to monitor the health of Oracle components.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4,5 |
|
MC |
|
|
| 98 |
1Z0-067 |
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery? |
|
Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
|
Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
|
Restore all the data files, recover them by using the recover database command, and open the database.
|
Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 97 |
1Z0-067 |
Which two statements are true about a common user?
|
|
A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
|
A common user with the create user privilege can create other common users, as well as local users.
|
A common user can be granted only a common role.
|
A common user can have a local schema in a PDB.
|
A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
| 96 |
1Z0-067 |
user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this? |
|
Use Data Pump.
|
Use ALTERTABLE. . .MOVE
|
Use CREATE TABLE AS SELECT
|
Use alter tablespace to encrypt the tablespace after enabling row movement on all its
|
Use altertablespace to encrypt the tablespace.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2,3 |
|
MC |
|
|
| 95 |
1Z0-067 |
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
|
|
The ADR base is shared across multiple instances.
|
The ADR base keeps all diagnostic information in binary format.
|
The ADR can be used to store statspack snapshots to diagnose database performance issues.
|
The ADR can be used for problem diagnosis even when the database instance is down.
|
The ADR is used to store Automatic Workload Repository (AWR) snapshots.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
| 94 |
1Z0-067 |
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: |
94-quept2.png |
The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
|
The command succeeds only if all the PDBs have the users and temp tablespaces.
|
The command gives an error because the container=all clause is missing.
|
The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does
not exist in that PDB. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 93 |
1Z0-067 |
For which two requirements would you use the Database Resource Manager?
|
|
limiting the CPU used per database call
|
specifying the maximum number of concurrent sessions allowed for a user
|
specifying the amount of private space a session can allocate in the shared pool of the SGA
|
limiting the degree of parallelism of operations performed by a user or group of users
|
specifying an idle time limit that applies to sessions that are idle and blocking other sessions
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,5 |
|
MC |
|
|
| 92 |
1Z0-067 |
You have a production Oracle 12c database running on a host. |
92.png |
2, 1, 6, and 4
|
2, 3, and 6
|
3, 1, 5, and 6
|
2, 3, 1, and 6
|
1, 5, and 4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 91 |
1Z0-067 |
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the
following: |
|
Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout theprocess.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend? |
DEALLOCATE UNUSED
|
SHRINK SPACE CASCADE
|
SHRINK SPACE COMPACT
|
ROW STORE COMPRESS BASIC
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 90 |
1Z0-067 |
Which three statements are true about the keystore storage framework for transparent data encryption?
|
|
It facilitates and helps to enforce keystore backup requirements.
|
It handles encrypted data without modifying applications.
|
It enables a keystore to be stored only in a file on a file system. |
It enables separation of duties between the database administrator and the security administrator.
|
It transparently decrypts data for the database users and applications that access this data.
|
It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4,6 |
|
MC |
|
|
| 89 |
1Z0-067 |
Examine the commands: |
89-quept2.png |
It recovers the structure, data, and indexes of the first emp table.
|
It recovers only the structure of the second emp table.
|
It returns an error because two tables with the same name exist in the recycle bin.
|
It recovers the structure, data, and indexes of the second emp table.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 88 |
1Z0-067 |
You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. |
88.png |
4, 8, 11, 5
|
1, 3, 8, 11, 9
|
1, 2, 6, 3, 7, 10, 9
|
1, 3, 7, 10, 9
|
1, 2, 6, 3, 8, 11, 9
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 87 |
1Z0-067 |
Examine the command to back up the ASM metadata: |
87-quept2.png |
when one or more disks in an ASM disk group are lost
|
when the data file on an ASM disk group gets corrupted
|
when one of the disks in a disk group is accidentally unplugged
|
when one or more file directory paths are accidentally deleted from an ASM disk group
|
when all the ASM disk groups for the ASM instance are lost |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,4 |
|
MC |
|
|
| 86 |
1Z0-067 |
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. |
86.png |
The statistics_level parameter is set to all when any of the PDBs is reopened.
|
The statistics_level parameter is set to all only for PDB2 when it is reopened.
|
The statistics_level parameter is set to all when the root database is restarted.
|
The statement is ignored because there is no SPFILE for a PDB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 85 |
1Z0-067 |
Your database is running in archivelog mode and regular nightly backups are taken. |
85.png |
1, 3, 4, 5
|
6, 3, 4, 5
|
2, 3, 4, 5
|
6, 4, 3, 5
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 84 |
1Z0-067 |
LDAP_DIRECTORY_SYSAUTH is set to YES. |
84-quept2.png |
authentication by password file |
authentication by using certificates over SSL
|
authentication by using the Oracle Internet Directory
|
authentication by using the local OS of the database server
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 83 |
1Z0-067 |
Which three statements are true about Oracle Secure Backup (OSB)?
|
|
It can encrypt client data written to tape.
|
It can be used to take image copy backups to tape.
|
It can be used to manage tape backup and restore operations for multiple databases.
|
It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
|
It can be used to perform file system backups at the file, directory, file system, or raw partition level.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,5 |
|
MC |
|
|
| 82 |
1Z0-067 |
Which two are prerequisites for creating a backup-based duplicate database?
|
|
connecting to the target database and a recovery catalog to execute the duplicate command
|
creating a password file for an auxiliary instance
|
connecting to an auxiliary instance
|
matching the database identifier (DBID) of the source database and the duplicate database |
creating an SPFILE for the target database
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 81 |
1Z0-067 |
Which two statements describe the relationship between a window, a resource plan, and a job class?
|
|
A window specifies a resource plan that will be activated when that window becomes active.
|
A window specifies a job class that will be activated when that window becomes active.
|
A job class specifies a window that will be open when that job class becomes active.
|
A window in association with a resource plan controls a job class allocation.
|
A window in association with a job class controls a resource allocation.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
|
|
| 80 |
1Z0-067 |
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?
|
|
A job is specified as part of a program definition.
|
A program can be used in the definition of multiple jobs.
|
A program and job can be specified as part of a schedule definition.
|
A program and schedule can be specified as part of a job definition.
|
A program and window can be specified as part of a job definition.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,4 |
|
MC |
|
|
| 79 |
1Z0-067 |
Your database is running in archivelog mode. |
79-quept2.png |
An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
|
Optional destinations cannot use the fast recovery area.
|
An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
|
These settings work only if log__archive_min_succeed_dest is set to a value of 4.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 78 |
1Z0-067 |
Examine the backup requirement for your company: |
78-quept2.png |
level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
|
level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
|
full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
|
full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 77 |
1Z0-067 |
Identify three benefits of unified auditing.
|
|
It helps to reduce disk space used to store an audit trail in a database.
|
It guarantees zero-loss auditing.
|
It reduces overhead on a database caused by auditing, by having a single audit trail.
|
An audit trail cannot be modified because it is read-only.
|
It automatically audits Recovery Manager (RMAN) events.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4,5 |
|
MC |
|
|
| 76 |
1Z0-067 |
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation? |
|
capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test
system |
capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
|
capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for
all PDBs |
capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 75 |
1Z0-067 |
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). |
75-quept2.png |
2, 1, 3, 4, 5, 6
|
1, 3, 4, 5, 6, 7
|
1, 4, 3, 5, 6, 7
|
2, 1, 3, 4, 5, 6, 7
|
1, 5, 6, 4, 3, 2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 74 |
1Z0-067 |
You are administering a multitenant container database (CDB) cdb1. |
74-quept2.png |
SALESPDB is created and is in mount state. |
PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.
|
SALESPDB is created and is in read/write mode.
|
PDB creation fails because a default temporary tablespace is not defined for SALESPDB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 73 |
1Z0-067 |
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? |
|
Configure backup optimization.
|
Configure the channel to increase maxopenfiles. |
Configure a backup policy by using incremental backups.
|
Configure the channel to increase capacity with the rate parameter.
|
Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
|
Configure large_pool, if not done already. Alternatively, you can increase the size of
|
LARGE_POOL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
|
|
| 72 |
1Z0-067 |
Which three statements are true about the SQL*Loader utility?
|
|
It can be used to load data from multiple external files into multiple tables.
|
It can be used to extract and reorganize data from external files, and then load it into a table.
|
It can be used to load data from external files using direct path only.
|
It can be used to create tables using data that is stored in external files.
|
It can be used to generate unique sequential values in specified columns while loading data.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,5 |
|
MC |
|
|
| 71 |
1Z0-067 |
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome? |
|
The PDB is closed.
|
The PDB is placed in mount state.
|
The command executes only if the common user is granted the set container privilege for the PDB.
|
The command results in an error because the PDB can be shut down only by a local user.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 70 |
1Z0-067 |
You execute the RMAN commands: |
70-quept2.png |
Corrupted blocks, if any, are repaired in the backup created.
|
Only those data files that have corrupted blocks are backed up.
|
Corrupted blocks in the data files are checked and repaired before performing the database backup.
|
The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 69 |
1Z0-067 |
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file? |
|
Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
|
Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the
instance.
|
Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
|
Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 68 |
1Z0-067 |
View the Exhibit showing steps to create a database resource manager plan. |
68-quept2.png |
The pending area is automatically submitted when creating plan directives.
|
The procedure must be executed before creating any plan directive.
|
The sys_group group is not included in the resource plan.
|
The other_groups group is not included in the resource plan.
|
Pending areas can not be validated until submitted.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 67 |
1Z0-067 |
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. |
67-quept2.png |
It fails because archive log files cannot be backed up using a connection to a PDB.
|
It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
|
It succeeds and all data files belonging to PD32_i are backed up along with the archive log files. |
It fails because the pluggable clause is missing.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 66 |
1Z0-067 |
You are required to migrate your 11.2.0.3 database to an Oracle 12c database. |
66-quept2.png |
1, 3, 5, 4, 2, and 6
|
1, 2, 4, 6, 5, 3, and 7
|
1, 2,4, and 7
|
2, 4, 5, 6, and 7
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 65 |
1Z0-067 |
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. |
65-quept2.png |
Set DB_FLASH_CACHE_SIZE=64G.
|
Set D3_FLASH_CACHE_SIZE=64G, 64G.
|
Set D3_FLASK_CACKE_SI2E=i28G.
|
db_flash_cache_SI2E is automatically configured by the instance at startup.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 64 |
1Z0-067 |
Which two statements are true regarding the Oracle Data Pump export and import operations?
|
|
You cannot export data from a remote database.
|
You can rename tables during import.
|
You can overwrite existing dump files during export.
|
You can compress data but not metadata during export.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 63 |
1Z0-067 |
You created a tablespace with this statement: |
63.png |
ALTER TA3LESPACE adtbs RESI2E 20G; |
ALTER TA3LESPACE adtbs ADD DATAFILE; |
ALTER TABLESPACE adtbs AUTOEXTEND ON; |
ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG; |
ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 62 |
1Z0-067 |
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. |
62-quept2.png |
The minimum size for the standard buffer cache is 100 MB.
|
The maximum size for the standard buffer cache is 100 MB.
|
The minimum space guaranteed in the buffer cache for any server process is 100 MB.
|
The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
|
The minimum size for all buffer caches is 100 MB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 61 |
1Z0-067 |
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database
instance because it hangs.
How can you detect the cause of the degraded performance? |
|
by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
|
by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
|
by using Active Session History (ASH) data and performing hang analysis
|
by running ADDM in diagnostic mode
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 60 |
1Z0-067 |
Examine the command: |
60-quept2.png |
dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statement is true about the execution of the command?
|
It fails because the log file parameter is not specified.
|
It fails because no absolute path is specified for the log file and dump file.
|
It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
|
It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed
three. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 59 |
1Z0-067 |
Examine the commands executed to monitor database operations: |
59-quept2.png |
Database operations will be monitored only when they consume a significant amount of resource.
|
Database operations for all sessions will be monitored.
|
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set
DIAGNISTIC + TUNING. |
Only DML and DDL statements will be monitored for the session.
|
All subsequent statements in the session will be treated as one database operation and will be monitored.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 58 |
1Z0-067 |
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. |
58-quept2.png |
An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
|
An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
|
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
|
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue
contention. |
A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 57 |
1Z0-067 |
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command? |
|
All redo log files are opened.
|
The root, the seed, and all the PDBs are opened in read-write mode.
|
All the PDBs are opened in read-write mode.
|
All the PDBs are in closed state.
|
Only the root database is opened in read-write mode.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5 |
|
SC |
|
|
| 56 |
1Z0-067 |
You issue commands in SQL*Plus as the Oracle owner, to enable multi threading for your UNIX- based Oracle 12c database: |
56-quept2.png |
because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
|
because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
|
because the threaded architecture requires authentication using a password file before issuing a startup command
|
because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
|
because the threaded architecture requires restarting the listener before issuing a startup command
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 55 |
1Z0-067 |
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance
because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance? |
|
Enable Memory Access Mode, which reads performance data from SGA.
|
Use emergency monitoring to fetch data directly from SGA for analysis.
|
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
|
Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
|
Run ADDM in diagnostic mode.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 54 |
1Z0-067 |
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. |
54-quept2.png |
All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
|
All data files belonging to pdb2_1 are backed up along with the archive log files.
|
Only the data files belonging to pdb2_ are backed up.
|
This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 53 |
1Z0-067 |
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users: |
|
1, 3, 5, 6, 2, 4
|
1, 3, 6, 2, 5, 4
|
1, 3, 2, 5, 6, 4 |
1, 3, 5, 2, 6, 4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 52 |
1Z0-067 |
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting? |
|
a hash cluster
|
an index cluster
|
a partitioned table
|
a sorted hash cluster
|
a heap table with a rowid column
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 51 |
1Z0-067 |
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
|
|
A PDB opened in restricted mode allows only local users to connect.
|
When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
|
When a CDB is in mount state, PDBs are automatically placed in mount state.
|
All PDBs must be shut down before shutting down a CDB instance.
|
When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,5 |
|
MC |
|
|
| 50 |
1Z0-067 |
You use RMAN with a recovery catalog to back up your database. |
50-quept2.png |
1, 8, 3, 2, 4, 5, 7, 6
|
8, 1, 3, 2, 4, 5, 7, 6
|
1, 3, 2, 4, 8, 5, 6, 7
|
8, 3, 2, 4, 5, 7, 6
|
8, 1, 3, 2, 4, 5, 6
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 49 |
1Z0-067 |
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
|
|
statistics recommendations
|
SQL profile recommendations
|
SQL statement restructure recommendations
|
creation of materialized views to improve query performance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 48 |
1Z0-067 |
You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. |
48-quept2.png |
The command performs the recovery and closes the failure.
|
The command produces an error because RMAN is not connected to the target database pdb_1.
|
The command produces an error because the advise failure command was not executed before the REPAIRFAILUER command.
|
The command executes successfully, performs recovery, and opens PDB_1.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 47 |
1Z0-067 |
You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this? |
|
The event parameter was not set.
|
The sql_trace parameter is set to false.
|
Enterprise Manager was not used.
|
The statistics_level parameter is set to basic.
|
The t:kid_statistics parameter is set to false.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 46 |
1Z0-067 |
Examine the command used to perform an incremental level-0 backup: |
46-quept2.png |
The block change tracking data is used only from the next incremental backup.
|
The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
|
The incremental level 1 backup does not use change tracking data for accomplishing the backup.
|
The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
|
The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 45 |
1Z0-067 |
Which four actions are possible during an Online Datafile Move operation? |
|
Creating and dropping tables in the datafile being moved
|
Performing file shrink of the data file being moved
|
Querying tables in the datafile being moved
|
Performing Block Media Recovery for a data block in the datafile being moved
|
Flashing back the database
|
Executing DML statements on objects stored in the datafile being moved
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,5,6 |
|
MC |
|
|
| 44 |
1Z0-067 |
Evaluate these statements: |
44-quept2.png |
Partitions of purchase_order_items are assigned unique names based on a sequence.
|
The purchase_orders and purchase_order_items tables are created with four partitioneach.
|
purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
|
The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
|
Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 43 |
1Z0-067 |
Users report this error message when inserting rows into the orders table: |
43-quept2.png |
drop and re-create the index
|
coalesce the orders,,ind index
|
coalesce the indexes tablespace
|
perform an on line table rebuild using dbns_redefir.ition. |
rebuild the index online moving it to another tablespace that has enough free space for the index
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3 |
|
MC |
|
|
| 42 |
1Z0-067 |
You must unload data from the orders, order_items, and products database tables to four files using the External Tables. |
42-quept2.png |
TYPE |
LOCATION |
PARALLEL |
DEFAULT DIRECTORY
|
ORGANIZATION EXTERNAL
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 41 |
1Z0-067 |
In your multitenant container database (CDB) that contains pluggable databases (PDBs). |
41-quept2.png |
Create the create_test procedure with definer's rights. |
Grant the execute privilege to users with grant option on the create_test procedure. |
Create the create_test procedure with invoker's rights. |
Create the create_test procedure as part of a package and grant users the execute privilege on the package. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 40 |
1Z0-067 |
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?
|
|
Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
|
All database listeners running from the database home are automatically added to the Oracle Restart configuration.
|
The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restartconfiguration.
|
The crsct1 start has command must be used to start software services for Oracle AutomaticStorage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
|
All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 39 |
1Z0-067 |
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak
workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance? |
|
SQL Performance Analyzer
|
SQL Access Advisor
|
SQL Tuning Advisor
|
Automatic Workload Repository (AWR) report
|
Automatic Database Diagnostic Monitor (ADDM)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 38 |
1Z0-067 |
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?
|
|
The compatible initialization parameter is set to 10.2 or higher.
|
There are no guaranteed restore points defined for the database.
|
The default device for the backup must be set to disk.
|
The tablespaces are locally managed. |
The fast recovery area is less than 50 percent free.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 37 |
1Z0-067 |
For your database, an incremental level 1 backup is taken every week day. |
37-quept2.png |
It returns an error because there is no level 0 backup available for new data files.
|
It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
|
It performs a level-0 backup of all data files including those that belong to the new tablespace.
|
It performs an image copy backup of all data files including those that belong to the new tablespace.
|
It performs a backup as a backup set of all data files including those that belong to the new tablespace.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3 |
|
MC |
|
|
| 36 |
1Z0-067 |
In which situation can you use Flashback Database?
|
|
when undoing a shrink data file operation
|
when retrieving a dropped tablespace |
when returning to a point in time before the restoration or re-creation of a control file
|
when returning to a point in time before the most recent open resetlogs operation
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3 |
|
MC |
|
|
| 35 |
1Z0-067 |
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
|
|
by using the connect statement as a local user having only the set container privilege
|
by using easy connect
|
by using external authentication
|
as a common user with the set container privilege
|
by executing the alter session set container command as a local user
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
|
|
| 34 |
1Z0-067 |
Your database instance is started using an SPFILE. |
34-quept2.png |
It is immediately set to all in the SPFILE and the CDB instance.
|
It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
|
It is immediately set to all only for cd3Sroot.
|
It is immediately set to all in all PDBs where the statistics_level parameter is not set.
|
It is set to all for all PDBs only in the SPFILE.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2 |
|
MC |
|
|
| 33 |
1Z0-067 |
You wish to enable an audit policy for all database users, except sys, system, and scott. |
33-quept2.png |
all users except sys
|
all users except scott
|
all users except sys and scott
|
all users except sys, system, and scott
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 32 |
1Z0-067 |
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
|
|
The backup must be performed in mount state.
|
The tablespace must be taken offline.
|
All files must be backed up as backup sets.
|
The database must be backed up as an image copy.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 31 |
1Z0-067 |
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB): |
31-quept2.png |
1, 4, 6, 5, 8, 3, 9
|
1, 6, 4, 5, 8, 3, 9
|
2, 4, 6, 5, 8, 3, 7
|
2, 4, 5, 8, 3, 7, 9
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 30 |
1Z0-067 |
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
|
|
Reduced logical I/O
|
Reduced virtual memory utilization
|
Improved Serial Execution performance
|
Reduced physical I/O
|
Reduced CPU utilization
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,3,5 |
|
MC |
|
|
| 29 |
1Z0-067 |
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?
|
|
tracking the most recent read time for a table segment in a user tablespace
|
tracking the most recent write time for a table segment in a user tablespace
|
tracking insert time by row for table rows
|
tracking the most recent write time for each block in a table segment
|
tracking the most recent read time for a table segment in the sysauxtablespace
|
tracking the most recent write time for a table segment in the sysauxtablespace
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2,4 |
|
MC |
|
|
| 28 |
1Z0-067 |
Examine the command to create a pluggable database (PDB): |
28-quept2.png |
The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
|
B. Details about the metadata describing pdb2 are stored in an XML file .
|
The tablespace specifications of pdb2 are the same as pdb1.
|
All database objects belonging to common users in PD3I are cloned in PD32. |
pdb2 is created with its own private undo and temp tablespaces.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 27 |
1Z0-067 |
Which two statements are true about a multitenant architecture?
|
|
Each pluggable database (PDB) has its own initialization parameter file.
|
A PDB can have a private undo tablespace.
|
Log switches occur only at the container database level.
|
A PDB can have a private temporary tablespace.
|
Each PDB has a private control file.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
| 26 |
1Z0-067 |
Examine these Data Pump commands to export and import objects from and to the same database. |
26-quept2.png |
expdp will fail because no path has been defined for the dumpfile. |
expdp will succeed but impdp will fail because the users do not exist.
|
impdp will create two users called hr1 and oe1 and import all objects to the new schemas.
|
impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 25 |
1Z0-067 |
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement? |
|
Minimal supplemental logging must be enabled.
|
The database must be running in archivelog mode.
|
Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
|
The flashback any table privilege must be granted to the user.
|
The select any transaction privilege must be granted to the user.
|
The recycle bin parameter must be set to on.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4,5 |
|
MC |
|
|
| 24 |
1Z0-067 |
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup? |
|
image copy backup by using RMAN
|
multisection image copy backup by using RMAN
|
multisection parallel backup by using RMAN
|
cold backup after taking the tablespace offline
|
cold backup after placing the tablespace in backup mode
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 23 |
1Z0-067 |
Identify two scenarios in which the RMAN crosscheck command can be used.
|
|
when checking for backups that are not required as per the retention policy
|
when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
|
when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
|
when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
|
when listing backups that are required for recovery operations
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 22 |
1Z0-067 |
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely
identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the
database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this? |
|
by using the RMAN switch command to set the new location for the data files
|
by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
|
by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
|
by creating a new database in the new host, and then using the RMAN recover command
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 21 |
1Z0-067 |
Which three RMAN persistent settings can be set for a database?
|
|
backup retention policy
|
default backup device type
|
default section size for backups
|
default destinations for backups
|
multiple backup device types for a single backup
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2,4 |
|
MC |
|
|
| 20 |
1Z0-067 |
On your Oracle 12c database, |
20-quept2.png |
It succeeds with default settings if the employees table exists in the hr schema.
|
It fails because no SQL*Loader data file location is specified.
|
It fails if the hr user does not have the create any directory privilege.
|
It fails because no SQL*Loader control file location is specified.
|
It succeeds and creates the employees table in the HR schema. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3 |
|
MC |
|
|
| 19 |
1Z0-067 |
Which two statements are true about dropping a pluggable database (PDB)?
|
|
A PDB must be in mount state or it must be unplugged.
|
The data files associated with a PDB are automatically removed from disk.
|
A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
|
A PDB must be in closed state.
|
The backups associated with a PDB are removed.
|
A PDB must have been opened at least once after creation.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4 |
|
MC |
|
|
| 18 |
1Z0-067 |
In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. |
18-quept2.png |
The tablespace will be renamed but the data file headers will not be updated.
|
The statement will fail because you cannot rename an undo tablespace.
|
The tablespace will be renamed and all the changes will be logged in the alert log.
|
D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
|
You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,5 |
|
MC |
|
|
| 17 |
1Z0-067 |
In which three scenarios is media recovery required?
|
|
when a tablespace is accidentally dropped from a database
|
when archived redo log files are lost
|
when data files are lost
|
when one of the online redo log members is corrupted
|
when all control files are lost
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,4,5 |
|
MC |
|
|
| 16 |
1Z0-067 |
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?
|
|
Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
|
Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from
the Oracle 11g database into the newly created PDB. |
Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
|
Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly
created PDB. |
Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,5 |
|
MC |
|
|
| 15 |
1Z0-067 |
Your database has a table customers that contains the columns cust_name, amt_due, and old_status. |
15-quept2.png |
Supplemental logging is not enabled for the database.
|
The undo data that existed for versions of rows before the change to the table structure is invalidated.
|
The db_flash3ACK_reteni:on_target parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
|
Undo retention guarantee is not enabled.
|
Flashback Data Archive is full after the first update statement.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
SC |
|
|
| 14 |
1Z0-067 |
You want to create a guaranteed restore point for your database |
14-quept2.png |
The database must be running in archivelog mode.
|
Flashback Database must be enabled.
|
Fast Recovery Area must be enabled.
|
The recyclebin must be enabled for the database.
|
Undo retention guarantee must be enabled.
|
A database backup must be taken.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3 |
|
MC |
|
|
| 13 |
1Z0-067 |
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows: |
13-quept2.png |
Re-enable redaction policies that use FULL data redaction.
|
Re-create redaction policies that use FULL data redaction.
|
Re-connect the sessions that access objects with redaction policies defined on them.
|
Flush the shared pool.
|
Restart the database instance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5 |
|
SC |
|
|
| 12 |
1Z0-067 |
Your database is running in archivelog mode and |
12-quept2.png |
1, 2, 5, 3, 6, 4
|
1, 2, 3, 5, 6, 4
|
2, 1, 5, 7, 3, 4
|
2, 1, 5, 6, 7, 4, 3
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 11 |
1Z0-067 |
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
|
|
Tables or table partitions can be recovered by using an auxiliary instance only.
|
Tables or table partitions with a foreign key cannot be recovered.
|
Tables or table partitions can be recovered only when the database is in mount state.
|
Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
|
Tables with not null constraints cannot be recovered.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4,5 |
|
MC |
|
|
| 10 |
1Z0-067 |
Identify three scenarios in which RMAN will use backup sets to perform active database duplication. |
|
when the duplicate ... from active database command contains the section size clause
|
when you perform active database duplication on a database with flashback disabled
|
when you specify set encryption before the duplicate ... from active database command
|
when the number of auxiliary channels allocated is equal to or greater than the number of target channels
|
when you perform active database duplication on a database that has read-onlytablespaces
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,3,4 |
|
MC |
|
|
| 9 |
1Z0-067 |
Your database is running in archivelog mode. Examine the parameters for your database instance: |
9th.png |
The database instance hangs and the redo log files are not overwritten.
|
The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
|
The database instance is shutdown immediately.
|
The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee
archive log success.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
SC |
|
|
| 8 |
1Z0-067 |
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
|
|
USERS |
SYSTEM |
SYSAUX |
EXAMPLE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 7 |
1Z0-067 |
The following parameters are set for your Oracle 12c database instance: |
07-queup2.png |
2, 4, 5
|
2, 1, 4, 3, 5
|
1, 2, 3, 4, 5
|
1, 2, 4, 5
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 6 |
1Z0-067 |
Examine the RMAN command: |
06-queup2.png |
password-mode encryption
|
dual-mode encryption
|
transparent encryption
|
default encryption
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 5 |
1Z0-067 |
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: |
05-queup2.png |
1, 4, 3, 2, 5
|
1, 3, 4, 5, 2
|
4, 3, 1, 2, 5
|
4, 3, 5, 1, 2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
SC |
|
|
| 4 |
1Z0-067 |
Examine the initialization parameter that is set in the PFILE: |
4th.png |
It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
|
The files created for both the root and seed databases use Oracle Managed Files (OMF).
|
It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
|
It sets the users tablespace as the default for both the root and seed databases.
|
undotbs1 is used as the undo tablespace for both the root and seed databases.
|
It creates a multitenant container database with the root database opened and the seed database mounted.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,2,3 |
|
MC |
|
|
| 3 |
1Z0-067 |
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. |
3rd.png |
3, 2, 1, 4
|
2, 3, 4, 1
|
4, 1, 3, 2
|
3, 2, 4, 1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
SC |
|
|
| 2 |
1Z0-067 |
Which three types of failures are detected by the Data Recovery Advisor (DRA)?
|
|
loss of a non-critical data file
|
loss of a control file
|
physical data block corruption
|
logical data block corruption
|
loss of an archived redo log file
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2,4,5 |
|
MC |
|
|
| 1 |
1Z0-067 |
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager? |
|
maximum undo per consumer group
|
maximum idle time for a session in a PDB
|
parallel server limit
|
CPU |
maximum number of sessions for a PDB
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3,4 |
|
MC |
|
|
